The Transform Variables node in SAS® Enterprise Miner™ enables you to specify a Dummy Indicators transformation for class variables. However, if two or more of the class variables that are transformed have names that are identical in the first 24 characters, then the results of the transformation are incorrect. The resulting "TI_.." variables are incorrectly created with identical names. Because names are identical, only one of each name is kept.
There are no errors or warnings to indicate that a problem occurred.
To determine whether the problem occurs in any specific case, examine the Transformations Statistics in the node results. Look in the Variable Name column. For any names that are identical, only one of them is kept in the exported data.
To work around the problem, make sure that no variable names are identical in the first 24 characters.
EXAMPLE
A data set contains these two class variables:
twenty_five_letter_var__1 with character values 1, 2, 3, 4
twenty_five_letter_var__2 with character values 5, 6
The first 24 characters of the two variable names are not unique: "twenty_five_letter_var__".
In the Transform Variables node, choose the Default Methods Class Inputs property, Dummy Indicators. Run the Transform Variables node. Right-click the node, and choose Results. The Transformations Statistics pane shows these variables:
TI_twenty_five_letter_var__1
TI_twenty_five_letter_var__2
TI_twenty_five_letter_var__3
TI_twenty_five_letter_var__4
TI_twenty_five_letter_var__1
TI_twenty_five_letter_var__2
However, the exported data shows only one set.
Variable Name Label
TI_twenty_five_letter_var__1 twenty_five_letter_var__2:5
TI_twenty_five_letter_var__2 twenty_five_letter_var__2:6
TI_twenty_five_letter_var__3 twenty_five_letter_var__1:3
TI_twenty_five_letter_var__4 twenty_five_letter_var__1:4
Operating System and Release Information
SAS System | SAS Enterprise Miner | z/OS | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows XP 64-bit Edition | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows 2000 Advanced Server | 5.3 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Datacenter Server | 5.3 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Server | 5.3 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Professional | 5.3 | | 9.1 TS1M3 SP4 | |
Microsoft Windows NT Workstation | 5.3 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Datacenter Edition | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise Edition | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Standard Edition | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows XP Professional | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Windows Vista | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Windows Vista for x64 | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
64-bit Enabled AIX | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
64-bit Enabled HP-UX | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
64-bit Enabled Solaris | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
HP-UX IPF | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Linux | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Linux on Itanium | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Solaris for x64 | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Tru64 UNIX | 5.3 | 12.1 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.